Y3Q2 Post-Mortem Analysis

Hornet Inc. (Company 2) -- World 1 -- Quarter ended Y3Q2
VERDICT: Solid Recovery Quarter -- Financial Moves Were Sound, Expansion Decision Is Overdue

01 Executive Scorecard

Net Income
$261K
+$13K vs Q1 ($248K)
Revenue
$3,652K
+$604K vs Q1 (+20%)
Market Share
18.7%
+1.0pp vs Q1 (17.7%)
Units Sold
346K
+67K vs Q1 (+24%)
Ending Cash
$1,329K
-$1,377K vs start ($2,707K)
Industry Rank (Profit)
#3
Down from #1 in Q1
The Big Picture
You improved from Q1. Revenue up 20%, units up 24%, share up 1pp. But you dropped from #1 most profitable to #3. Company 1 leapfrogged you with $362K net income. The team decided not to expand this quarter, so idle capital was optimized through bond refinancing ($500K callback at ~7.5%, reissuable at 4.80%) and CDs ($2,200K at 3.24%). These were sound financial moves given that no expansion was planned. However, the strategic gap is widening -- Companies 3 & 4 are investing that same level of capital into Nystok plants that will transform their cost structures.

02 Your Decisions vs Results

DecisionQ1 (Actual)Q2 (Entered)ChangeImpact
Price (Merica)$10.50$10.20 -$0.30 (-2.9%) Gained ~1pp share
Price (Nystok)Dn 79Dn 75 -Dn 4 (-5.1%) Nystok share: 19% (up from 18%)
Advertising (Merica total)$137K$168K +$31K (+23%) Helped offset competitors
Advertising (Nystok)Dn 116KDn 110K -Dn 6K (-5%) Flat -- could have gained more
Commission20%22% +2pp Small step toward 70/30 goal
Salespeople Hired0+2 (Area 2 + Nystok) Good 1 in training each area
Production Hours48 (OT)40 (normal) Eliminated overtime Unit cost ROSE to $5.41 (was $4.85)
Quality/Features (Area 2)Q2/F2Q3/F3 Premium positioning +20% production cost from Q3/F3
R&D$90K$90K No change Steady
Training$68K$75K +$7K (+10%) Good -- never decrease per Tips
Bond Callback--$500K New action Used $525K cash, saves $6K/qtr
CDs$1,200K$2,200K +$1,000K Locked up cash for 3.24% annual return
Dividends$0$0 No change Should have started ($50K)

03 The Unit Cost Surprise -- $5.41 vs Expected ~$4.30

BIGGEST NEGATIVE SURPRISE: Unit cost jumped from $4.85 to $5.41 (+11.5%)
You expected dropping overtime (48hrs to 40hrs) would LOWER unit cost. Instead it INCREASED by $0.56/unit. Here's why:
Cost ComponentQ1 (48hrs, Q2/F2)Q2 (40hrs, Q3/F3)ChangeWhy
Labor~$2.88 (with OT)$1,049K / 324K = $3.24+$0.36 Q3/F3 adds +20% to labor (10% each). Offset OT savings.
Materials~$1.23$489K / 324K = $1.51+$0.28 Q3/F3 adds +20% to materials
Maintenance~$0.25$80K / 324K = $0.25Flat Not affected by Q/F
Depreciation$0.35$133K / 324K = $0.41+$0.06 Less units to spread fixed cost over
Total$4.85$5.41+$0.56 (+11.5%) Q3/F3 premium wiped out OT savings
Manual Reference
BPG Manual Ch.7: "For Quality 3 add 10%. For Features 3 add 10%." These compound: Q3/F3 = 1.10 x 1.10 = 1.21x (21% increase) to labor and materials. Your overtime savings (~15% labor premium removed) were more than consumed by the +21% Q3/F3 cost uplift. Net effect: you're paying $0.56 MORE per unit for a premium product. This isn't necessarily bad IF you charge enough to cover it -- but at $10.20 you only gained $0.56 in cost, reducing gross margin.

Standard costs for NEXT quarter (from Report E): Labor $2.63 + Materials $1.42 = $4.05/unit base (Q2/F2). At Q3/F3: $4.05 x 1.21 = $4.90/unit. This confirms the cost structure.

04 Cash Flow -- Where Did the $700K Go?

You expected ~$2,000K ending cash. Actual: $1,329K. The gap: $671K.
Let me trace every dollar.
ItemAmount ($K)Notes
OPERATING RECEIPTS: $3,356K
Accounts Collected$3,341KQ1 AR + 50% of Q2 Merica sales + 40% Nystok
CD Interest$15K2.76% annual on $1,200K Q1 CDs = $8.3K (actual $15K includes accrual)
Subsidiary Dividends$49KNystok sub paid dividends to parent
OPERATING EXPENDITURES: $3,233K
Interest Paid-$38KBond interest (before callback -- paid on full $2,000K)
Production Cost-$1,643K2/3 current + 1/3 prior quarter. THIS IS THE BIG ONE.
Purchases from Affiliates-$0K(consolidated)
Operating Expense-$1,336K2/3 current + 1/3 prior quarter operating costs
Taxes Paid-$216KQ1's taxes paid this quarter (higher than expected)
Net Operating Cash Flow$123KBarely positive
INVESTMENT: -$1,000K
CDs Matured+$1,200KQ1 CDs returned
CDs Purchased-$2,200K$1,000K MORE than what matured
FINANCING: -$500K
Bonds Repurchased-$500KCallback (no 5% premium shown separately)
Nystok Dividends to Parent-$291K (Dn)Internal transfer, nets out consolidated
Beginning Cash$2,706K
Net Cash Flow-$1,377K
ENDING CASH$1,329K
Why You're $671K Short of $2,000K Target
1. Taxes were higher than expected: $216K (Q1 taxes of $170K Merica + taxes from Nystok sub)
2. Production cost cash outflow: $1,643K -- This includes 1/3 of Q1's production cost PLUS 2/3 of Q2's. Your Q1 overtime production (376K units at $4.85 = $1,823K) created deferred payments flowing into Q2.
3. Operating expenses: $1,336K -- Again includes Q1 deferred costs.
4. Bond interest still charged on full $2,000K: $38K -- The callback happens DURING the quarter, so you pay interest on the full amount first.

The lesson: BPG's cash flow timing rules (1/3 deferred) mean Q1's expensive overtime production ($1,823K) sent ~$608K of deferred costs into Q2. You budgeted based on Q2 costs alone and forgot about Q1's tail.

05 Competitive Landscape -- Q1 vs Q2

CompanyQ1 ShareQ2 ShareChangeQ1 ProfitQ2 ProfitChangeStrategy
Co. 1 (AttiPals)19.3%18.9%-0.4pp $232K$362K+$130K Held $10.00, conservative. Now #1 profit.
Co. 2 (US)17.7%18.7%+1.0pp $248K$261K+$13K Dropped price $0.30, increased ads. Modest recovery.
Co. 3 (Gordon)20.6%21.1%+0.5pp $147K$272K+$125K Dropped to $9.60-9.70. 6-line Nystok plant building.
Co. 4 (SJSU)23.4%23.1%-0.3pp $5K$107K+$102K Still $9.00 but profit recovering. 8-line Nystok plant.
Co. 5 (CSUN)18.9%18.2%-0.7pp $149K$173K+$24K Dropped to $9.69-9.79. Added 2 new lines. Waking up.
CRITICAL: Everyone Improved More Than You
CompanyProfit Increase Q1-Q2Your Gap
Company 1+$130K (+56%)They gained 10x more profit than you
Company 3+$125K (+85%)Nearly doubled profit while building Nystok plant
Company 4+$102K (+2,040%)Recovering from near-death
Company 5+$24K (+16%)Modest but adding capacity
YOU+$13K (+5%)Smallest improvement of all 5 companies

Industry Pricing Trends

CompanyQ1 Price (M1)Q2 Price (M1)ChangeDirection
Co. 1$10.00$10.00$0.00Holding steady
Co. 2 (US)$10.50$10.20-$0.30Dropped toward market
Co. 3$9.80$9.70-$0.10Slightly more aggressive
Co. 4$9.00$9.00$0.00Holding rock bottom
Co. 5$10.00$9.79-$0.21Dropped -- joining price war
The Market is Converging Downward
Average industry price: Q1 = $9.86, Q2 = $9.74. The trend is DOWN. You're still the highest at $10.20. Company 5 abandoned their $10.00 hold and dropped. Company 1 is the only one holding at $10.00. You're increasingly isolated at the premium end with no product differentiation to justify it -- everyone is still at Q2/F2 on the position map.

Expansion Race -- WHO'S BUILDING WHAT

CompanyQ1 ActionQ2 StatusReady WhenImpact
Co. 1NothingNothing--Conservative like you
Co. 2 (US)NothingNothing--No expansion planned
Co. 3Started 6-line NystokUnder constructionY3Q4Massive capacity + cheap labor in 2 qtrs
Co. 4Started 8-line NystokUnder constructionY3Q4Biggest plant in the game in 2 qtrs
Co. 5NothingAdded 2 new lines (home plant)Y3Q3Extra 104K capacity next quarter
YOU ARE NOW THE ONLY COMPANY NOT INVESTING IN CAPACITY
Company 1 was your "conservative buddy" in Q1. Now even Company 5 is adding 2 lines. You are literally the only company in the industry with zero expansion activity. In 2 quarters, Companies 3 & 4 will have Nystok plants producing at Dn 7.92 labor + Dn 6.40 materials = Dn 14.32/unit (~$2.39 USD) vs your $5.41/unit. They'll produce at 56% lower cost.

06 Model Prediction Accuracy

Comparing our calibrated model predictions (from bpg_engine_v2.py at $10.00 price) to actual results at $10.20 price:

MetricModel Predicted (at $10.00)Actual (at $10.20)ErrorAccuracy
Market Share19.5-19.7%18.7% ~1.0pp over
94%
Total Units~329K346K -17K under (5%)
95%
Revenue~$3,290K$3,652K -$362K under (10%)
90%
Net Income~$235K$261K -$26K under (10%)
90%
Unit Prod. Cost~$4.30$5.41 -$1.11 (26% miss)
74%
Ending Inventory~170K164K +6K (4%)
96%
Overall Accuracy
~90%
Market-side predictions strong
Cost Prediction
74%
Q3/F3 impact was not modeled
Model Accuracy Assessment
Market-side predictions (share, units, revenue): 90-95% accurate. The model correctly predicted the Q2 seasonal uplift and price sensitivity. Revenue was underestimated because the model was calibrated for $10.00 and you entered $10.20 -- higher price x similar volume = more revenue than predicted.

Cost-side prediction: 74% accurate. The model did NOT properly account for the Q3/F3 quality/features cost multiplier. This is a known gap -- the model needs to be updated with the actual Q3/F3 = 1.21x cost multiplier. I will fix this in the calibrated model.

Cash flow prediction: The biggest miss. The model didn't account for BPG's deferred payment timing rules (1/3 of Q1's costs flowing into Q2). This needs to be added to the pro forma tool.

07 What Went GOOD

1. Market Share Recovery (+1.0pp)
Dropping price to $10.20 and increasing advertising recaptured 1pp of market share (17.7% to 18.7%). You sold 346K units vs 279K in Q1 -- a 24% increase. The seasonal Q2 boost helped, but your pricing/marketing adjustments drove real improvement.
2. Revenue Growth (+20%)
$3,652K vs $3,048K. Despite a lower price ($10.20 vs $10.50), the volume increase more than compensated. This proves that the market IS elastic -- volume gains from lower prices exceed the per-unit revenue loss.
3. Eliminated Overtime -- Right Call
Going from 48hrs to 40hrs was correct. You had 186K units of inventory to burn through. Production output dropped from 376K to 324K, and inventory decreased from 186K to 164K. You're working down the excess. Overtime would have been wasteful.
4. Hired 2 Salespeople -- Good Long-term Move
1 in Area 2 (Home), 1 in Nystok. Both in training now. They'll be fully productive next quarter. This builds capacity for future growth, especially in Nystok where demand is about to surge.
5. Increased Training to $75K -- Smart
Training spending increased from $68K to $75K. The Tips say "never decrease training." This pushes you toward the next savings level, which reduces future production costs by ~2%.
6. Best Altman Z Score in Industry (2.18)
Your financial health score is the highest -- better than every competitor including Company 1 (2.15). Companies 3 (1.89) and 4 (1.92) are stretching themselves thin with expansion debt. You have financial stability.
7. Highest Interest Coverage (16.3x)
You can cover your debt obligations 16.3 times over. This is the best in the industry. Company 4 is at 7.4x (dangerous). This gives you flexibility to take on debt later if needed.

08 What Went WRONG

1. DROPPED FROM #1 TO #3 IN PROFITABILITY
Q1: You were the MOST profitable company ($248K). Q2: You're #3 behind Company 1 ($362K) and Company 3 ($272K). Your profit grew only $13K (+5%) while the industry average grew $96K (+73%). This is the worst relative performance of any company.
2. Unit Cost Explosion ($4.85 to $5.41)
Choosing Q3/F3 positioning for Area 2 (home area where production happens) increased your production cost by 21%. This ate into margins and is the primary reason profit barely grew despite 20% revenue increase. Revenue up $604K but COGS up $405K. You captured barely $200K of that $604K as gross profit.
3. Bond Callback + CDs -- Sound Financial Moves, But Expansion Was the Better Use of Capital
Since no expansion was planned for Q2, idle capital was put to work:

What was done:
- Bond callback at ~7.5% coupon, reissuable later at 4.80% = textbook refinancing (saves ~$6.4K/quarter ongoing)
- $2,200K in CDs at 3.24% = $17.8K/quarter vs 0% sitting in cash
- Combined financial income: ~$24K/quarter from idle cash

These were the right financial moves given that expansion wasn't happening. With no plant to fund, parking cash in CDs and refinancing debt was the responsible move. However, the opportunity cost is real: that same capital deployed into a Nystok plant would return 20%+ vs 3.24% in CDs. The team must align on expansion for Q3 -- the data now proves the case.
4. Still Zero Expansion -- Only Company Not Investing
As of Q2, expansion status: Co.3 = 6-line Nystok plant. Co.4 = 8-line Nystok plant. Co.5 = 2 new home lines. Co.1 = nothing yet but highest cash reserves ($4,571K) to move quickly. Hornet Inc. is the ONLY company with zero capacity investment.

The competitive analysis (Section 5 of this report) makes it clear: expansion is no longer optional. The window is closing -- if construction starts in Q3, the plant is ready by Y4Q2. Every quarter of delay extends the cost disadvantage.
5. Sales Office Orders Were Too Low
Your orders: 85/87/85/40 = 297K total. Customer orders: 95/100/94/53 = 342K. You could have sold 342K units but only authorized 297K! You left 45K units of demand on the table. At $10.20/unit that's ~$459K in lost revenue. You actually sold 346K (some excess inventory filled demand), but the order caps constrained you.
6. No Dividends Started
Every winning team in the Tips for Success started dividends by Year 3. You've now gone 2 quarters without paying a single dollar. The judges will notice. No company has started dividends yet, but you should be first -- it's a differentiation signal to judges.
7. Price Drop to $10.20 -- Necessary but Looks Inconsistent
Q1: $10.50. Q2: $10.20. This is exactly the "inconsistency" the Tips warned about. If judges ask "why did you raise then immediately lower?", the answer sounds reactive. The $0.30 drop gained you only 1pp of share -- Company 5 dropped $0.21 and LOST 0.7pp. Price isn't the only lever, and your drop wasn't decisive enough to make a real difference.

09 Income Statement Deep Dive

Line ItemQ1Q2ChangeAnalysis
Revenue$3,048K$3,652K+$604K (+20%)Volume + seasonal drove growth
COGS$1,335K$1,740K+$405K (+30%)Q3/F3 cost + higher volume
VAT$71K$66K-$5KSlightly less Nystok revenue share
Gross Profit$1,713K$1,846K+$133K56.2% margin down to 50.5%
Advertising$156K$186K+$30KIntentional increase
Sales Salaries$120K$126K+$6K2 new hires + slight increase
Sales Commissions$56K$69K+$13KHigher commission % + more revenue
General Selling$400K$418K+$18KMore units sold = higher variable
Transportation$155K$174K+$19KMore units shipped
R&D$90K$90K$0Unchanged
Training$68K$91K+$23K$75K entered + $10K new hire + Dn 37K Nystok hire
Storage$19K$46K+$27KHigher average inventory carried
Operating Profit$447K$458K+$11KBarely grew despite 20% revenue increase
Bond Interest$38K$38K$0Full quarter interest before callback
CD Interest$8K$15K+$7KHigher CD balance
Tax$170K$170K$0Nearly identical
NET INCOME$248K$261K +$13KOnly +5% despite 20% revenue growth
The Margin Squeeze Problem
Revenue grew $604K but net income grew only $13K. Where did the $591K go?
- COGS absorbed $405K (Q3/F3 premium + volume)
- Operating expenses grew $121K (advertising, selling, storage, training)
- Tax absorbed $0K more (coincidence -- similar pretax)
- Interest net improved $7K
Bottom line: The Q3/F3 cost increase ($0.56/unit x 346K units = ~$194K) was the single biggest profit drag. If you had stayed at Q2/F2, your net income would have been approximately $261K + $194K x 0.61 (after tax) = ~$379K -- beating Company 1 for #1 profitability.

10 Balance Sheet Health

ItemQ1 EndQ2 EndChange
Cash$2,707K$1,329K-$1,378K
CDs$1,200K$2,200K+$1,000K
Total Liquidity$3,907K$3,529K-$378K
Accounts Receivable$1,524K$1,892K+$368K (higher sales)
Inventory$902K$995K+$93K (higher unit cost)
Total Assets$15,070K$14,867K-$203K
Bonds$2,000K$1,500K-$500K (callback)
Total Equity$11,881K$12,143K+$262K (retained earnings)
Current Ratio5.4x5.2x-0.2x (still strong)

11 Brutally Honest Verdict

The Good News

You're financially solid. Best Altman Z, best interest coverage, reasonable profit. You recovered 1pp of market share. You're not in danger of bankruptcy. Your balance sheet is clean.

The Bad News

You had the smallest profit improvement of any company in the industry. You went from #1 profitability to #3. You're the only company not investing in future capacity. Your Q3/F3 quality/features decision ate your margins without delivering meaningful differentiation (everyone is still clustered at Q2/F2 on the position map -- your Q3/F3 only applies to your home area production, NOT to how the market sees your product in Areas 1, 3, and Nystok which are still Q2/F2).

The Scary Part

In 2 quarters, Companies 3 and 4 will have Nystok plants online. Company 5 will have 2 extra lines. Your $5.41 unit cost will be competing against their ~$2.50 Nystok cost. They'll be able to undercut you by $2+/unit AND be profitable. Your "differentiation" at Q2/F2 positioning (same as everyone else) with $10.20 pricing will become untenable.

The window to start a Nystok plant is CLOSING. If you start in Y3Q3, it's ready Y4Q2. If you wait until Y3Q4, it's Y4Q3. Every quarter you delay is a quarter of competitive disadvantage.

12 Key Data for Model Calibration Update

ParameterQ1 ValueQ2 ActualModel Needs Update?
Total Industry Sales1,574K1,850KYes -- Q2 seasonal uplift = 17.5%
Market Share at $10.2017.7% at $10.5018.7% at $10.20Yes -- price elasticity confirmed ~2.0
Unit Production Cost (Q3/F3)$4.85 (Q2/F2, 48hr)$5.41 (Q3/F3, 40hr)Yes -- add Q/F cost multiplier
Standard costs next qtr--Labor $2.63, Material $1.42Yes -- update base costs
Savings Level--Level 1 (shown in Report E)Yes -- lower than assumed (was 3)
Seasonal factor Q1-Q20.921.01 (1,574 to 1,850 = +17.5%)Yes -- actual ratio = 1.175
Exchange rate5.975.99Minor update
CD Rate2.76%3.24%Rising -- update
Bond Rate (CR2)4.90%4.80%Slightly lower -- update
Nystok GDP (Q11 forecast)106.49106.65Confirmed: Nystok boom coming
CRITICAL: Savings Level = 1 (Not 3 as assumed)
Report E shows "Savings Level 1." The model assumed Level 3 based on Y1-Y2 cumulative training. This means training investment has less impact than modeled. At Level 1, you need ~$200K cumulative training to reach Level 2 (which reduces costs ~2%). You've spent $68K + $75K = $143K so far. You're close to Level 2 but not there yet.

13 The Case for Expansion: Why We Must Act in Q3

STRATEGIC INVESTMENT MEMO -- HORNET INC.

RE: Nystok Plant Investment Required Y3Q3

THE COMPETITIVE REALITY

We are now the only company in the industry with zero capacity investment. The Q2 industry report confirms:

  • Company 3: 6-line Nystok plant under construction (ready Y3Q4) + $3M in bonds to fund it
  • Company 4: 8-line Nystok plant under construction (ready Y3Q4) -- the largest in the game
  • Company 5: Added 2 new production lines (online Y3Q3)
  • Company 1: $4,571K liquidity -- positioned to move at any time
  • Us: Nothing. Zero investment. Standing still.

THE COST CRISIS COMING IN 2 QUARTERS

Our current unit cost (Q3/F3, Merica) $5.41
Nystok unit cost (Co.3 & 4, Y3Q4 onward) ~$2.50
Their cost advantage per unit $2.91 (54% cheaper)
On 200K units/year from Nystok plant $582K/year cost advantage over us

They will be able to price at $8.00 and still match our margins at $10.20. Our differentiation strategy becomes meaningless without a cost structure to support it.

THE NYSTOK GDP EXPLOSION

The ACCUDAT GDP forecast confirms Nystok is about to boom:

Y3Q2 (now)102.56
Y3Q3106.65 (+4.0%)
Y3Q4111.41 (+4.5%)
Y4Q2114.41 (+2.7%)

Nystok GDP grows 11.5% over the next 4 quarters vs Merica's 3.5%. The growth market is Nystok. Companies 3 & 4 will capture it. We won't.

THE PROPOSAL: 4-LINE NYSTOK PLANT

Plant construction (3 quarters) ~$633K/quarter = $1,900K total
Equipment (4 lines, in Q3 of construction) $2,400K
Total investment ~$4,300K over 3 quarters
Funding: Issue $1-1.5M bonds at 4.80% Cost: $12-18K/quarter interest
Funding: Reduce CDs from $2,200K to $1,000K Frees up $1,200K (lose $10K/qtr CD interest)
Plant operational Y4Q2
Annual cost savings (est.) $400K-600K/year

ROI: The plant pays for itself in under 2 years. Bond interest costs ~$60K/year. Cost savings are $400K+/year. Net benefit: $340K+/year.

WHAT HAPPENS IF WE DO NOTHING

  • Y3Q4: Companies 3 & 4 plants come online. Their costs drop 54%. They gain pricing power.
  • Y4Q1-Q2: Our market share drops below 16% as we can't compete on price.
  • Y4Q3-Q4: We're stuck with the highest cost structure and lowest market share.
  • Y5 onward: We become a marginal player with no competitive advantage.
  • The judges will ask: "Why didn't you invest when you had the cash and the data?"

RECOMMENDATION: Approve 4-line Nystok plant construction in Y3Q3. Fund with bond issue + CD reduction. Maintain $1.5M+ cash buffer throughout construction. This is the single most important strategic decision of the competition.